package com.jiangwh.dao.mapper;

import java.util.List;

import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.jiangwh.dao.entity.MacBindInfo;

@Repository
@CacheNamespace(implementation=org.mybatis.caches.ehcache.LoggingEhcache.class)
public interface Dao {
	
	
	@Select("SELECT MAC_BIND_INFO_UUID,MAC,USER_ID,TERMINAL_TYPE,OS_TYPE,MAC_MOOD,LAST_UPDATE_TIME,LAST_UNBIND_TIME FROM MAC_BIND_INFO")
	@Results({
		@Result(property="MacBindInfoUuid",column="MAC_BIND_INFO_UUID"),
		@Result(property="mac",column="MAC"),
		@Result(property="userId",column="USER_ID"),
		@Result(property="TerminalType",column="TERMINAL_TYPE"),
		@Result(property="osType",column="OS_TYPE"),
		@Result(property="macMood",column="MAC_MOOD"),
		@Result(property="lastUpdateTime",column="LAST_UPDATE_TIME"),
		@Result(property="lastUnbindTime",column="LAST_UNBIND_TIME")
	})
	List<MacBindInfo> getMacBindInfos();
	
}